Nick Korna
Nick Korna
Reactions
-
Re: Countifs to Consider More than one drop down in one range of data
Hi @Brianne, You can get round this by introducing some OR & CONTAINS: =COUNTIFS({Site Wide SOC's 2024 Range 2}:{Site Wide SOC's 2024 Range 2}, OR(CONTAINS("Plant Maintenance", @cell), …1 · -
Re: February 29th Automations?
Hi @Jack Parry, It should do - you can see in the calendar for when to start an automation that Feb this year has 29 days but next year only it only has 28.1 · -
Re: What is Unparseable about this formula?
Hi @bhsiao_regcorp, You need some @cell references in there (assuming your cross sheet ranges are OK): =SUMIFS({Daily Sales Tracking Range 5}, {Daily Sales Tracking Range 2}, @cell >= [Week Start]…1 · -
Re: Symbol, Checkbox, Percent Complete formulas
Hi @Eddie Endurium LLC Depending on how your sheets are arranged, you can do this with either a VLOOKUP or an INDEX/COLLECT and some cross sheet references. For example, to pull the symbol from Sheet…1 · -
Re: If Then Date
Hi @GSA Rob, You're looking for a nice nested IF/AND formula here, along these lines: =IF(AND([Project Type]@row = "N Type", [3. RWA Acceptance Date (PM/Kayla)]@row <> "", […1 ·
